package com.zhongwang.mms.gen.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class BShoppingPlanExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BShoppingPlanExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSppIdIsNull() {
            addCriterion("spp_id is null");
            return (Criteria) this;
        }

        public Criteria andSppIdIsNotNull() {
            addCriterion("spp_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppIdEqualTo(Integer value) {
            addCriterion("spp_id =", value, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdNotEqualTo(Integer value) {
            addCriterion("spp_id <>", value, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdGreaterThan(Integer value) {
            addCriterion("spp_id >", value, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_id >=", value, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdLessThan(Integer value) {
            addCriterion("spp_id <", value, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_id <=", value, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdIn(List<Integer> values) {
            addCriterion("spp_id in", values, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdNotIn(List<Integer> values) {
            addCriterion("spp_id not in", values, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_id between", value1, value2, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_id not between", value1, value2, "sppId");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeIsNull() {
            addCriterion("spp_track_code is null");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeIsNotNull() {
            addCriterion("spp_track_code is not null");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeEqualTo(String value) {
            addCriterion("spp_track_code =", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeNotEqualTo(String value) {
            addCriterion("spp_track_code <>", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeGreaterThan(String value) {
            addCriterion("spp_track_code >", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spp_track_code >=", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeLessThan(String value) {
            addCriterion("spp_track_code <", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeLessThanOrEqualTo(String value) {
            addCriterion("spp_track_code <=", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeLike(String value) {
            addCriterion("spp_track_code like", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeNotLike(String value) {
            addCriterion("spp_track_code not like", value, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeIn(List<String> values) {
            addCriterion("spp_track_code in", values, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeNotIn(List<String> values) {
            addCriterion("spp_track_code not in", values, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeBetween(String value1, String value2) {
            addCriterion("spp_track_code between", value1, value2, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppTrackCodeNotBetween(String value1, String value2) {
            addCriterion("spp_track_code not between", value1, value2, "sppTrackCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeIsNull() {
            addCriterion("spp_mat_code is null");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeIsNotNull() {
            addCriterion("spp_mat_code is not null");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeEqualTo(String value) {
            addCriterion("spp_mat_code =", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeNotEqualTo(String value) {
            addCriterion("spp_mat_code <>", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeGreaterThan(String value) {
            addCriterion("spp_mat_code >", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spp_mat_code >=", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeLessThan(String value) {
            addCriterion("spp_mat_code <", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeLessThanOrEqualTo(String value) {
            addCriterion("spp_mat_code <=", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeLike(String value) {
            addCriterion("spp_mat_code like", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeNotLike(String value) {
            addCriterion("spp_mat_code not like", value, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeIn(List<String> values) {
            addCriterion("spp_mat_code in", values, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeNotIn(List<String> values) {
            addCriterion("spp_mat_code not in", values, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeBetween(String value1, String value2) {
            addCriterion("spp_mat_code between", value1, value2, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatCodeNotBetween(String value1, String value2) {
            addCriterion("spp_mat_code not between", value1, value2, "sppMatCode");
            return (Criteria) this;
        }

        public Criteria andSppMatDescIsNull() {
            addCriterion("spp_mat_desc is null");
            return (Criteria) this;
        }

        public Criteria andSppMatDescIsNotNull() {
            addCriterion("spp_mat_desc is not null");
            return (Criteria) this;
        }

        public Criteria andSppMatDescEqualTo(String value) {
            addCriterion("spp_mat_desc =", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescNotEqualTo(String value) {
            addCriterion("spp_mat_desc <>", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescGreaterThan(String value) {
            addCriterion("spp_mat_desc >", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescGreaterThanOrEqualTo(String value) {
            addCriterion("spp_mat_desc >=", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescLessThan(String value) {
            addCriterion("spp_mat_desc <", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescLessThanOrEqualTo(String value) {
            addCriterion("spp_mat_desc <=", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescLike(String value) {
            addCriterion("spp_mat_desc like", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescNotLike(String value) {
            addCriterion("spp_mat_desc not like", value, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescIn(List<String> values) {
            addCriterion("spp_mat_desc in", values, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescNotIn(List<String> values) {
            addCriterion("spp_mat_desc not in", values, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescBetween(String value1, String value2) {
            addCriterion("spp_mat_desc between", value1, value2, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppMatDescNotBetween(String value1, String value2) {
            addCriterion("spp_mat_desc not between", value1, value2, "sppMatDesc");
            return (Criteria) this;
        }

        public Criteria andSppNumIsNull() {
            addCriterion("spp_num is null");
            return (Criteria) this;
        }

        public Criteria andSppNumIsNotNull() {
            addCriterion("spp_num is not null");
            return (Criteria) this;
        }

        public Criteria andSppNumEqualTo(Double value) {
            addCriterion("spp_num =", value, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumNotEqualTo(Double value) {
            addCriterion("spp_num <>", value, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumGreaterThan(Double value) {
            addCriterion("spp_num >", value, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumGreaterThanOrEqualTo(Double value) {
            addCriterion("spp_num >=", value, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumLessThan(Double value) {
            addCriterion("spp_num <", value, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumLessThanOrEqualTo(Double value) {
            addCriterion("spp_num <=", value, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumIn(List<Double> values) {
            addCriterion("spp_num in", values, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumNotIn(List<Double> values) {
            addCriterion("spp_num not in", values, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumBetween(Double value1, Double value2) {
            addCriterion("spp_num between", value1, value2, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppNumNotBetween(Double value1, Double value2) {
            addCriterion("spp_num not between", value1, value2, "sppNum");
            return (Criteria) this;
        }

        public Criteria andSppUnitIsNull() {
            addCriterion("spp_unit is null");
            return (Criteria) this;
        }

        public Criteria andSppUnitIsNotNull() {
            addCriterion("spp_unit is not null");
            return (Criteria) this;
        }

        public Criteria andSppUnitEqualTo(String value) {
            addCriterion("spp_unit =", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitNotEqualTo(String value) {
            addCriterion("spp_unit <>", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitGreaterThan(String value) {
            addCriterion("spp_unit >", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitGreaterThanOrEqualTo(String value) {
            addCriterion("spp_unit >=", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitLessThan(String value) {
            addCriterion("spp_unit <", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitLessThanOrEqualTo(String value) {
            addCriterion("spp_unit <=", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitLike(String value) {
            addCriterion("spp_unit like", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitNotLike(String value) {
            addCriterion("spp_unit not like", value, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitIn(List<String> values) {
            addCriterion("spp_unit in", values, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitNotIn(List<String> values) {
            addCriterion("spp_unit not in", values, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitBetween(String value1, String value2) {
            addCriterion("spp_unit between", value1, value2, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppUnitNotBetween(String value1, String value2) {
            addCriterion("spp_unit not between", value1, value2, "sppUnit");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoIsNull() {
            addCriterion("spp_standard_no is null");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoIsNotNull() {
            addCriterion("spp_standard_no is not null");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoEqualTo(String value) {
            addCriterion("spp_standard_no =", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoNotEqualTo(String value) {
            addCriterion("spp_standard_no <>", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoGreaterThan(String value) {
            addCriterion("spp_standard_no >", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoGreaterThanOrEqualTo(String value) {
            addCriterion("spp_standard_no >=", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoLessThan(String value) {
            addCriterion("spp_standard_no <", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoLessThanOrEqualTo(String value) {
            addCriterion("spp_standard_no <=", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoLike(String value) {
            addCriterion("spp_standard_no like", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoNotLike(String value) {
            addCriterion("spp_standard_no not like", value, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoIn(List<String> values) {
            addCriterion("spp_standard_no in", values, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoNotIn(List<String> values) {
            addCriterion("spp_standard_no not in", values, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoBetween(String value1, String value2) {
            addCriterion("spp_standard_no between", value1, value2, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppStandardNoNotBetween(String value1, String value2) {
            addCriterion("spp_standard_no not between", value1, value2, "sppStandardNo");
            return (Criteria) this;
        }

        public Criteria andSppCategoryIsNull() {
            addCriterion("spp_category is null");
            return (Criteria) this;
        }

        public Criteria andSppCategoryIsNotNull() {
            addCriterion("spp_category is not null");
            return (Criteria) this;
        }

        public Criteria andSppCategoryEqualTo(String value) {
            addCriterion("spp_category =", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryNotEqualTo(String value) {
            addCriterion("spp_category <>", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryGreaterThan(String value) {
            addCriterion("spp_category >", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryGreaterThanOrEqualTo(String value) {
            addCriterion("spp_category >=", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryLessThan(String value) {
            addCriterion("spp_category <", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryLessThanOrEqualTo(String value) {
            addCriterion("spp_category <=", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryLike(String value) {
            addCriterion("spp_category like", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryNotLike(String value) {
            addCriterion("spp_category not like", value, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryIn(List<String> values) {
            addCriterion("spp_category in", values, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryNotIn(List<String> values) {
            addCriterion("spp_category not in", values, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryBetween(String value1, String value2) {
            addCriterion("spp_category between", value1, value2, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppCategoryNotBetween(String value1, String value2) {
            addCriterion("spp_category not between", value1, value2, "sppCategory");
            return (Criteria) this;
        }

        public Criteria andSppBrandIsNull() {
            addCriterion("spp_brand is null");
            return (Criteria) this;
        }

        public Criteria andSppBrandIsNotNull() {
            addCriterion("spp_brand is not null");
            return (Criteria) this;
        }

        public Criteria andSppBrandEqualTo(String value) {
            addCriterion("spp_brand =", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandNotEqualTo(String value) {
            addCriterion("spp_brand <>", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandGreaterThan(String value) {
            addCriterion("spp_brand >", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandGreaterThanOrEqualTo(String value) {
            addCriterion("spp_brand >=", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandLessThan(String value) {
            addCriterion("spp_brand <", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandLessThanOrEqualTo(String value) {
            addCriterion("spp_brand <=", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandLike(String value) {
            addCriterion("spp_brand like", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandNotLike(String value) {
            addCriterion("spp_brand not like", value, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandIn(List<String> values) {
            addCriterion("spp_brand in", values, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandNotIn(List<String> values) {
            addCriterion("spp_brand not in", values, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandBetween(String value1, String value2) {
            addCriterion("spp_brand between", value1, value2, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppBrandNotBetween(String value1, String value2) {
            addCriterion("spp_brand not between", value1, value2, "sppBrand");
            return (Criteria) this;
        }

        public Criteria andSppRemarkIsNull() {
            addCriterion("spp_remark is null");
            return (Criteria) this;
        }

        public Criteria andSppRemarkIsNotNull() {
            addCriterion("spp_remark is not null");
            return (Criteria) this;
        }

        public Criteria andSppRemarkEqualTo(String value) {
            addCriterion("spp_remark =", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkNotEqualTo(String value) {
            addCriterion("spp_remark <>", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkGreaterThan(String value) {
            addCriterion("spp_remark >", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("spp_remark >=", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkLessThan(String value) {
            addCriterion("spp_remark <", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkLessThanOrEqualTo(String value) {
            addCriterion("spp_remark <=", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkLike(String value) {
            addCriterion("spp_remark like", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkNotLike(String value) {
            addCriterion("spp_remark not like", value, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkIn(List<String> values) {
            addCriterion("spp_remark in", values, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkNotIn(List<String> values) {
            addCriterion("spp_remark not in", values, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkBetween(String value1, String value2) {
            addCriterion("spp_remark between", value1, value2, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppRemarkNotBetween(String value1, String value2) {
            addCriterion("spp_remark not between", value1, value2, "sppRemark");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameIsNull() {
            addCriterion("spp_project_name is null");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameIsNotNull() {
            addCriterion("spp_project_name is not null");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameEqualTo(String value) {
            addCriterion("spp_project_name =", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameNotEqualTo(String value) {
            addCriterion("spp_project_name <>", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameGreaterThan(String value) {
            addCriterion("spp_project_name >", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameGreaterThanOrEqualTo(String value) {
            addCriterion("spp_project_name >=", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameLessThan(String value) {
            addCriterion("spp_project_name <", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameLessThanOrEqualTo(String value) {
            addCriterion("spp_project_name <=", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameLike(String value) {
            addCriterion("spp_project_name like", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameNotLike(String value) {
            addCriterion("spp_project_name not like", value, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameIn(List<String> values) {
            addCriterion("spp_project_name in", values, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameNotIn(List<String> values) {
            addCriterion("spp_project_name not in", values, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameBetween(String value1, String value2) {
            addCriterion("spp_project_name between", value1, value2, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectNameNotBetween(String value1, String value2) {
            addCriterion("spp_project_name not between", value1, value2, "sppProjectName");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeIsNull() {
            addCriterion("spp_project_code is null");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeIsNotNull() {
            addCriterion("spp_project_code is not null");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeEqualTo(String value) {
            addCriterion("spp_project_code =", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeNotEqualTo(String value) {
            addCriterion("spp_project_code <>", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeGreaterThan(String value) {
            addCriterion("spp_project_code >", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spp_project_code >=", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeLessThan(String value) {
            addCriterion("spp_project_code <", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeLessThanOrEqualTo(String value) {
            addCriterion("spp_project_code <=", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeLike(String value) {
            addCriterion("spp_project_code like", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeNotLike(String value) {
            addCriterion("spp_project_code not like", value, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeIn(List<String> values) {
            addCriterion("spp_project_code in", values, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeNotIn(List<String> values) {
            addCriterion("spp_project_code not in", values, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeBetween(String value1, String value2) {
            addCriterion("spp_project_code between", value1, value2, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppProjectCodeNotBetween(String value1, String value2) {
            addCriterion("spp_project_code not between", value1, value2, "sppProjectCode");
            return (Criteria) this;
        }

        public Criteria andSppPartIsNull() {
            addCriterion("spp_part is null");
            return (Criteria) this;
        }

        public Criteria andSppPartIsNotNull() {
            addCriterion("spp_part is not null");
            return (Criteria) this;
        }

        public Criteria andSppPartEqualTo(String value) {
            addCriterion("spp_part =", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartNotEqualTo(String value) {
            addCriterion("spp_part <>", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartGreaterThan(String value) {
            addCriterion("spp_part >", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartGreaterThanOrEqualTo(String value) {
            addCriterion("spp_part >=", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartLessThan(String value) {
            addCriterion("spp_part <", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartLessThanOrEqualTo(String value) {
            addCriterion("spp_part <=", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartLike(String value) {
            addCriterion("spp_part like", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartNotLike(String value) {
            addCriterion("spp_part not like", value, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartIn(List<String> values) {
            addCriterion("spp_part in", values, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartNotIn(List<String> values) {
            addCriterion("spp_part not in", values, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartBetween(String value1, String value2) {
            addCriterion("spp_part between", value1, value2, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppPartNotBetween(String value1, String value2) {
            addCriterion("spp_part not between", value1, value2, "sppPart");
            return (Criteria) this;
        }

        public Criteria andSppDesignerIsNull() {
            addCriterion("spp_designer is null");
            return (Criteria) this;
        }

        public Criteria andSppDesignerIsNotNull() {
            addCriterion("spp_designer is not null");
            return (Criteria) this;
        }

        public Criteria andSppDesignerEqualTo(String value) {
            addCriterion("spp_designer =", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerNotEqualTo(String value) {
            addCriterion("spp_designer <>", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerGreaterThan(String value) {
            addCriterion("spp_designer >", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerGreaterThanOrEqualTo(String value) {
            addCriterion("spp_designer >=", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerLessThan(String value) {
            addCriterion("spp_designer <", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerLessThanOrEqualTo(String value) {
            addCriterion("spp_designer <=", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerLike(String value) {
            addCriterion("spp_designer like", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerNotLike(String value) {
            addCriterion("spp_designer not like", value, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerIn(List<String> values) {
            addCriterion("spp_designer in", values, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerNotIn(List<String> values) {
            addCriterion("spp_designer not in", values, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerBetween(String value1, String value2) {
            addCriterion("spp_designer between", value1, value2, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppDesignerNotBetween(String value1, String value2) {
            addCriterion("spp_designer not between", value1, value2, "sppDesigner");
            return (Criteria) this;
        }

        public Criteria andSppTelIsNull() {
            addCriterion("spp_tel is null");
            return (Criteria) this;
        }

        public Criteria andSppTelIsNotNull() {
            addCriterion("spp_tel is not null");
            return (Criteria) this;
        }

        public Criteria andSppTelEqualTo(String value) {
            addCriterion("spp_tel =", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelNotEqualTo(String value) {
            addCriterion("spp_tel <>", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelGreaterThan(String value) {
            addCriterion("spp_tel >", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelGreaterThanOrEqualTo(String value) {
            addCriterion("spp_tel >=", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelLessThan(String value) {
            addCriterion("spp_tel <", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelLessThanOrEqualTo(String value) {
            addCriterion("spp_tel <=", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelLike(String value) {
            addCriterion("spp_tel like", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelNotLike(String value) {
            addCriterion("spp_tel not like", value, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelIn(List<String> values) {
            addCriterion("spp_tel in", values, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelNotIn(List<String> values) {
            addCriterion("spp_tel not in", values, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelBetween(String value1, String value2) {
            addCriterion("spp_tel between", value1, value2, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppTelNotBetween(String value1, String value2) {
            addCriterion("spp_tel not between", value1, value2, "sppTel");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeIsNull() {
            addCriterion("spp_create_time is null");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeIsNotNull() {
            addCriterion("spp_create_time is not null");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeEqualTo(Date value) {
            addCriterion("spp_create_time =", value, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeNotEqualTo(Date value) {
            addCriterion("spp_create_time <>", value, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeGreaterThan(Date value) {
            addCriterion("spp_create_time >", value, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_create_time >=", value, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeLessThan(Date value) {
            addCriterion("spp_create_time <", value, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("spp_create_time <=", value, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeIn(List<Date> values) {
            addCriterion("spp_create_time in", values, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeNotIn(List<Date> values) {
            addCriterion("spp_create_time not in", values, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeBetween(Date value1, Date value2) {
            addCriterion("spp_create_time between", value1, value2, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("spp_create_time not between", value1, value2, "sppCreateTime");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserIsNull() {
            addCriterion("spp_create_user is null");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserIsNotNull() {
            addCriterion("spp_create_user is not null");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserEqualTo(String value) {
            addCriterion("spp_create_user =", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserNotEqualTo(String value) {
            addCriterion("spp_create_user <>", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserGreaterThan(String value) {
            addCriterion("spp_create_user >", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("spp_create_user >=", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserLessThan(String value) {
            addCriterion("spp_create_user <", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserLessThanOrEqualTo(String value) {
            addCriterion("spp_create_user <=", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserLike(String value) {
            addCriterion("spp_create_user like", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserNotLike(String value) {
            addCriterion("spp_create_user not like", value, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserIn(List<String> values) {
            addCriterion("spp_create_user in", values, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserNotIn(List<String> values) {
            addCriterion("spp_create_user not in", values, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserBetween(String value1, String value2) {
            addCriterion("spp_create_user between", value1, value2, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppCreateUserNotBetween(String value1, String value2) {
            addCriterion("spp_create_user not between", value1, value2, "sppCreateUser");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameIsNull() {
            addCriterion("spp_type_name is null");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameIsNotNull() {
            addCriterion("spp_type_name is not null");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameEqualTo(String value) {
            addCriterion("spp_type_name =", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameNotEqualTo(String value) {
            addCriterion("spp_type_name <>", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameGreaterThan(String value) {
            addCriterion("spp_type_name >", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameGreaterThanOrEqualTo(String value) {
            addCriterion("spp_type_name >=", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameLessThan(String value) {
            addCriterion("spp_type_name <", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameLessThanOrEqualTo(String value) {
            addCriterion("spp_type_name <=", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameLike(String value) {
            addCriterion("spp_type_name like", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameNotLike(String value) {
            addCriterion("spp_type_name not like", value, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameIn(List<String> values) {
            addCriterion("spp_type_name in", values, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameNotIn(List<String> values) {
            addCriterion("spp_type_name not in", values, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameBetween(String value1, String value2) {
            addCriterion("spp_type_name between", value1, value2, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeNameNotBetween(String value1, String value2) {
            addCriterion("spp_type_name not between", value1, value2, "sppTypeName");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdIsNull() {
            addCriterion("spp_type_id is null");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdIsNotNull() {
            addCriterion("spp_type_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdEqualTo(Integer value) {
            addCriterion("spp_type_id =", value, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdNotEqualTo(Integer value) {
            addCriterion("spp_type_id <>", value, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdGreaterThan(Integer value) {
            addCriterion("spp_type_id >", value, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_type_id >=", value, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdLessThan(Integer value) {
            addCriterion("spp_type_id <", value, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_type_id <=", value, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdIn(List<Integer> values) {
            addCriterion("spp_type_id in", values, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdNotIn(List<Integer> values) {
            addCriterion("spp_type_id not in", values, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_type_id between", value1, value2, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppTypeIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_type_id not between", value1, value2, "sppTypeId");
            return (Criteria) this;
        }

        public Criteria andSppBuyerIsNull() {
            addCriterion("spp_buyer is null");
            return (Criteria) this;
        }

        public Criteria andSppBuyerIsNotNull() {
            addCriterion("spp_buyer is not null");
            return (Criteria) this;
        }

        public Criteria andSppBuyerEqualTo(String value) {
            addCriterion("spp_buyer =", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerNotEqualTo(String value) {
            addCriterion("spp_buyer <>", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerGreaterThan(String value) {
            addCriterion("spp_buyer >", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerGreaterThanOrEqualTo(String value) {
            addCriterion("spp_buyer >=", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerLessThan(String value) {
            addCriterion("spp_buyer <", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerLessThanOrEqualTo(String value) {
            addCriterion("spp_buyer <=", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerLike(String value) {
            addCriterion("spp_buyer like", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerNotLike(String value) {
            addCriterion("spp_buyer not like", value, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerIn(List<String> values) {
            addCriterion("spp_buyer in", values, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerNotIn(List<String> values) {
            addCriterion("spp_buyer not in", values, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerBetween(String value1, String value2) {
            addCriterion("spp_buyer between", value1, value2, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppBuyerNotBetween(String value1, String value2) {
            addCriterion("spp_buyer not between", value1, value2, "sppBuyer");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleIsNull() {
            addCriterion("spp_pay_cycle is null");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleIsNotNull() {
            addCriterion("spp_pay_cycle is not null");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleEqualTo(Integer value) {
            addCriterion("spp_pay_cycle =", value, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleNotEqualTo(Integer value) {
            addCriterion("spp_pay_cycle <>", value, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleGreaterThan(Integer value) {
            addCriterion("spp_pay_cycle >", value, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_pay_cycle >=", value, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleLessThan(Integer value) {
            addCriterion("spp_pay_cycle <", value, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleLessThanOrEqualTo(Integer value) {
            addCriterion("spp_pay_cycle <=", value, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleIn(List<Integer> values) {
            addCriterion("spp_pay_cycle in", values, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleNotIn(List<Integer> values) {
            addCriterion("spp_pay_cycle not in", values, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleBetween(Integer value1, Integer value2) {
            addCriterion("spp_pay_cycle between", value1, value2, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppPayCycleNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_pay_cycle not between", value1, value2, "sppPayCycle");
            return (Criteria) this;
        }

        public Criteria andSppProgressIsNull() {
            addCriterion("spp_progress is null");
            return (Criteria) this;
        }

        public Criteria andSppProgressIsNotNull() {
            addCriterion("spp_progress is not null");
            return (Criteria) this;
        }

        public Criteria andSppProgressEqualTo(String value) {
            addCriterion("spp_progress =", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressNotEqualTo(String value) {
            addCriterion("spp_progress <>", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressGreaterThan(String value) {
            addCriterion("spp_progress >", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressGreaterThanOrEqualTo(String value) {
            addCriterion("spp_progress >=", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressLessThan(String value) {
            addCriterion("spp_progress <", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressLessThanOrEqualTo(String value) {
            addCriterion("spp_progress <=", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressLike(String value) {
            addCriterion("spp_progress like", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressNotLike(String value) {
            addCriterion("spp_progress not like", value, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressIn(List<String> values) {
            addCriterion("spp_progress in", values, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressNotIn(List<String> values) {
            addCriterion("spp_progress not in", values, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressBetween(String value1, String value2) {
            addCriterion("spp_progress between", value1, value2, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppProgressNotBetween(String value1, String value2) {
            addCriterion("spp_progress not between", value1, value2, "sppProgress");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusIsNull() {
            addCriterion("spp_import_status is null");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusIsNotNull() {
            addCriterion("spp_import_status is not null");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusEqualTo(Integer value) {
            addCriterion("spp_import_status =", value, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusNotEqualTo(Integer value) {
            addCriterion("spp_import_status <>", value, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusGreaterThan(Integer value) {
            addCriterion("spp_import_status >", value, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_import_status >=", value, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusLessThan(Integer value) {
            addCriterion("spp_import_status <", value, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spp_import_status <=", value, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusIn(List<Integer> values) {
            addCriterion("spp_import_status in", values, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusNotIn(List<Integer> values) {
            addCriterion("spp_import_status not in", values, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusBetween(Integer value1, Integer value2) {
            addCriterion("spp_import_status between", value1, value2, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_import_status not between", value1, value2, "sppImportStatus");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdIsNull() {
            addCriterion("spp_import_log_id is null");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdIsNotNull() {
            addCriterion("spp_import_log_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdEqualTo(Integer value) {
            addCriterion("spp_import_log_id =", value, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdNotEqualTo(Integer value) {
            addCriterion("spp_import_log_id <>", value, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdGreaterThan(Integer value) {
            addCriterion("spp_import_log_id >", value, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_import_log_id >=", value, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdLessThan(Integer value) {
            addCriterion("spp_import_log_id <", value, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_import_log_id <=", value, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdIn(List<Integer> values) {
            addCriterion("spp_import_log_id in", values, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdNotIn(List<Integer> values) {
            addCriterion("spp_import_log_id not in", values, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_import_log_id between", value1, value2, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppImportLogIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_import_log_id not between", value1, value2, "sppImportLogId");
            return (Criteria) this;
        }

        public Criteria andSppStatusIsNull() {
            addCriterion("spp_status is null");
            return (Criteria) this;
        }

        public Criteria andSppStatusIsNotNull() {
            addCriterion("spp_status is not null");
            return (Criteria) this;
        }

        public Criteria andSppStatusEqualTo(Integer value) {
            addCriterion("spp_status =", value, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusNotEqualTo(Integer value) {
            addCriterion("spp_status <>", value, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusGreaterThan(Integer value) {
            addCriterion("spp_status >", value, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_status >=", value, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusLessThan(Integer value) {
            addCriterion("spp_status <", value, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spp_status <=", value, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusIn(List<Integer> values) {
            addCriterion("spp_status in", values, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusNotIn(List<Integer> values) {
            addCriterion("spp_status not in", values, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusBetween(Integer value1, Integer value2) {
            addCriterion("spp_status between", value1, value2, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_status not between", value1, value2, "sppStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusIsNull() {
            addCriterion("spp_change_status is null");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusIsNotNull() {
            addCriterion("spp_change_status is not null");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusEqualTo(Integer value) {
            addCriterion("spp_change_status =", value, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusNotEqualTo(Integer value) {
            addCriterion("spp_change_status <>", value, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusGreaterThan(Integer value) {
            addCriterion("spp_change_status >", value, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_change_status >=", value, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusLessThan(Integer value) {
            addCriterion("spp_change_status <", value, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spp_change_status <=", value, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusIn(List<Integer> values) {
            addCriterion("spp_change_status in", values, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusNotIn(List<Integer> values) {
            addCriterion("spp_change_status not in", values, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusBetween(Integer value1, Integer value2) {
            addCriterion("spp_change_status between", value1, value2, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppChangeStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_change_status not between", value1, value2, "sppChangeStatus");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdIsNull() {
            addCriterion("spp_spc_id is null");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdIsNotNull() {
            addCriterion("spp_spc_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdEqualTo(Integer value) {
            addCriterion("spp_spc_id =", value, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdNotEqualTo(Integer value) {
            addCriterion("spp_spc_id <>", value, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdGreaterThan(Integer value) {
            addCriterion("spp_spc_id >", value, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_spc_id >=", value, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdLessThan(Integer value) {
            addCriterion("spp_spc_id <", value, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_spc_id <=", value, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdIn(List<Integer> values) {
            addCriterion("spp_spc_id in", values, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdNotIn(List<Integer> values) {
            addCriterion("spp_spc_id not in", values, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_spc_id between", value1, value2, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppSpcIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_spc_id not between", value1, value2, "sppSpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdIsNull() {
            addCriterion("spp_rpc_id is null");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdIsNotNull() {
            addCriterion("spp_rpc_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdEqualTo(Integer value) {
            addCriterion("spp_rpc_id =", value, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdNotEqualTo(Integer value) {
            addCriterion("spp_rpc_id <>", value, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdGreaterThan(Integer value) {
            addCriterion("spp_rpc_id >", value, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_rpc_id >=", value, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdLessThan(Integer value) {
            addCriterion("spp_rpc_id <", value, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_rpc_id <=", value, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdIn(List<Integer> values) {
            addCriterion("spp_rpc_id in", values, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdNotIn(List<Integer> values) {
            addCriterion("spp_rpc_id not in", values, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_rpc_id between", value1, value2, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppRpcIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_rpc_id not between", value1, value2, "sppRpcId");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagIsNull() {
            addCriterion("spp_integra_flag is null");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagIsNotNull() {
            addCriterion("spp_integra_flag is not null");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagEqualTo(Integer value) {
            addCriterion("spp_integra_flag =", value, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagNotEqualTo(Integer value) {
            addCriterion("spp_integra_flag <>", value, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagGreaterThan(Integer value) {
            addCriterion("spp_integra_flag >", value, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_integra_flag >=", value, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagLessThan(Integer value) {
            addCriterion("spp_integra_flag <", value, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagLessThanOrEqualTo(Integer value) {
            addCriterion("spp_integra_flag <=", value, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagIn(List<Integer> values) {
            addCriterion("spp_integra_flag in", values, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagNotIn(List<Integer> values) {
            addCriterion("spp_integra_flag not in", values, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagBetween(Integer value1, Integer value2) {
            addCriterion("spp_integra_flag between", value1, value2, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppIntegraFlagNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_integra_flag not between", value1, value2, "sppIntegraFlag");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdIsNull() {
            addCriterion("spp_oda_id is null");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdIsNotNull() {
            addCriterion("spp_oda_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdEqualTo(Integer value) {
            addCriterion("spp_oda_id =", value, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdNotEqualTo(Integer value) {
            addCriterion("spp_oda_id <>", value, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdGreaterThan(Integer value) {
            addCriterion("spp_oda_id >", value, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_oda_id >=", value, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdLessThan(Integer value) {
            addCriterion("spp_oda_id <", value, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_oda_id <=", value, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdIn(List<Integer> values) {
            addCriterion("spp_oda_id in", values, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdNotIn(List<Integer> values) {
            addCriterion("spp_oda_id not in", values, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_oda_id between", value1, value2, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppOdaIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_oda_id not between", value1, value2, "sppOdaId");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusIsNull() {
            addCriterion("spp_ret_status is null");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusIsNotNull() {
            addCriterion("spp_ret_status is not null");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusEqualTo(Integer value) {
            addCriterion("spp_ret_status =", value, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusNotEqualTo(Integer value) {
            addCriterion("spp_ret_status <>", value, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusGreaterThan(Integer value) {
            addCriterion("spp_ret_status >", value, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_ret_status >=", value, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusLessThan(Integer value) {
            addCriterion("spp_ret_status <", value, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spp_ret_status <=", value, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusIn(List<Integer> values) {
            addCriterion("spp_ret_status in", values, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusNotIn(List<Integer> values) {
            addCriterion("spp_ret_status not in", values, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusBetween(Integer value1, Integer value2) {
            addCriterion("spp_ret_status between", value1, value2, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppRetStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_ret_status not between", value1, value2, "sppRetStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreDateIsNull() {
            addCriterion("spp_pre_date is null");
            return (Criteria) this;
        }

        public Criteria andSppPreDateIsNotNull() {
            addCriterion("spp_pre_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppPreDateEqualTo(Date value) {
            addCriterion("spp_pre_date =", value, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateNotEqualTo(Date value) {
            addCriterion("spp_pre_date <>", value, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateGreaterThan(Date value) {
            addCriterion("spp_pre_date >", value, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_pre_date >=", value, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateLessThan(Date value) {
            addCriterion("spp_pre_date <", value, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_pre_date <=", value, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateIn(List<Date> values) {
            addCriterion("spp_pre_date in", values, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateNotIn(List<Date> values) {
            addCriterion("spp_pre_date not in", values, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateBetween(Date value1, Date value2) {
            addCriterion("spp_pre_date between", value1, value2, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_pre_date not between", value1, value2, "sppPreDate");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusIsNull() {
            addCriterion("spp_pre_status is null");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusIsNotNull() {
            addCriterion("spp_pre_status is not null");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusEqualTo(Integer value) {
            addCriterion("spp_pre_status =", value, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusNotEqualTo(Integer value) {
            addCriterion("spp_pre_status <>", value, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusGreaterThan(Integer value) {
            addCriterion("spp_pre_status >", value, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_pre_status >=", value, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusLessThan(Integer value) {
            addCriterion("spp_pre_status <", value, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusLessThanOrEqualTo(Integer value) {
            addCriterion("spp_pre_status <=", value, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusIn(List<Integer> values) {
            addCriterion("spp_pre_status in", values, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusNotIn(List<Integer> values) {
            addCriterion("spp_pre_status not in", values, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusBetween(Integer value1, Integer value2) {
            addCriterion("spp_pre_status between", value1, value2, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppPreStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_pre_status not between", value1, value2, "sppPreStatus");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeIsNull() {
            addCriterion("spp_sap_code is null");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeIsNotNull() {
            addCriterion("spp_sap_code is not null");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeEqualTo(String value) {
            addCriterion("spp_sap_code =", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeNotEqualTo(String value) {
            addCriterion("spp_sap_code <>", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeGreaterThan(String value) {
            addCriterion("spp_sap_code >", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeGreaterThanOrEqualTo(String value) {
            addCriterion("spp_sap_code >=", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeLessThan(String value) {
            addCriterion("spp_sap_code <", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeLessThanOrEqualTo(String value) {
            addCriterion("spp_sap_code <=", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeLike(String value) {
            addCriterion("spp_sap_code like", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeNotLike(String value) {
            addCriterion("spp_sap_code not like", value, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeIn(List<String> values) {
            addCriterion("spp_sap_code in", values, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeNotIn(List<String> values) {
            addCriterion("spp_sap_code not in", values, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeBetween(String value1, String value2) {
            addCriterion("spp_sap_code between", value1, value2, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppSapCodeNotBetween(String value1, String value2) {
            addCriterion("spp_sap_code not between", value1, value2, "sppSapCode");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdIsNull() {
            addCriterion("spp_whi_id is null");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdIsNotNull() {
            addCriterion("spp_whi_id is not null");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdEqualTo(Integer value) {
            addCriterion("spp_whi_id =", value, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdNotEqualTo(Integer value) {
            addCriterion("spp_whi_id <>", value, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdGreaterThan(Integer value) {
            addCriterion("spp_whi_id >", value, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_whi_id >=", value, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdLessThan(Integer value) {
            addCriterion("spp_whi_id <", value, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdLessThanOrEqualTo(Integer value) {
            addCriterion("spp_whi_id <=", value, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdIn(List<Integer> values) {
            addCriterion("spp_whi_id in", values, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdNotIn(List<Integer> values) {
            addCriterion("spp_whi_id not in", values, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdBetween(Integer value1, Integer value2) {
            addCriterion("spp_whi_id between", value1, value2, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppWhiIdNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_whi_id not between", value1, value2, "sppWhiId");
            return (Criteria) this;
        }

        public Criteria andSppPlannerIsNull() {
            addCriterion("spp_planner is null");
            return (Criteria) this;
        }

        public Criteria andSppPlannerIsNotNull() {
            addCriterion("spp_planner is not null");
            return (Criteria) this;
        }

        public Criteria andSppPlannerEqualTo(String value) {
            addCriterion("spp_planner =", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerNotEqualTo(String value) {
            addCriterion("spp_planner <>", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerGreaterThan(String value) {
            addCriterion("spp_planner >", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerGreaterThanOrEqualTo(String value) {
            addCriterion("spp_planner >=", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerLessThan(String value) {
            addCriterion("spp_planner <", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerLessThanOrEqualTo(String value) {
            addCriterion("spp_planner <=", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerLike(String value) {
            addCriterion("spp_planner like", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerNotLike(String value) {
            addCriterion("spp_planner not like", value, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerIn(List<String> values) {
            addCriterion("spp_planner in", values, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerNotIn(List<String> values) {
            addCriterion("spp_planner not in", values, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerBetween(String value1, String value2) {
            addCriterion("spp_planner between", value1, value2, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppPlannerNotBetween(String value1, String value2) {
            addCriterion("spp_planner not between", value1, value2, "sppPlanner");
            return (Criteria) this;
        }

        public Criteria andSppSupplierIsNull() {
            addCriterion("spp_supplier is null");
            return (Criteria) this;
        }

        public Criteria andSppSupplierIsNotNull() {
            addCriterion("spp_supplier is not null");
            return (Criteria) this;
        }

        public Criteria andSppSupplierEqualTo(String value) {
            addCriterion("spp_supplier =", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierNotEqualTo(String value) {
            addCriterion("spp_supplier <>", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierGreaterThan(String value) {
            addCriterion("spp_supplier >", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierGreaterThanOrEqualTo(String value) {
            addCriterion("spp_supplier >=", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierLessThan(String value) {
            addCriterion("spp_supplier <", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierLessThanOrEqualTo(String value) {
            addCriterion("spp_supplier <=", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierLike(String value) {
            addCriterion("spp_supplier like", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierNotLike(String value) {
            addCriterion("spp_supplier not like", value, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierIn(List<String> values) {
            addCriterion("spp_supplier in", values, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierNotIn(List<String> values) {
            addCriterion("spp_supplier not in", values, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierBetween(String value1, String value2) {
            addCriterion("spp_supplier between", value1, value2, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSupplierNotBetween(String value1, String value2) {
            addCriterion("spp_supplier not between", value1, value2, "sppSupplier");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeIsNull() {
            addCriterion("spp_steel_code is null");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeIsNotNull() {
            addCriterion("spp_steel_code is not null");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeEqualTo(Integer value) {
            addCriterion("spp_steel_code =", value, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeNotEqualTo(Integer value) {
            addCriterion("spp_steel_code <>", value, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeGreaterThan(Integer value) {
            addCriterion("spp_steel_code >", value, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("spp_steel_code >=", value, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeLessThan(Integer value) {
            addCriterion("spp_steel_code <", value, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeLessThanOrEqualTo(Integer value) {
            addCriterion("spp_steel_code <=", value, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeIn(List<Integer> values) {
            addCriterion("spp_steel_code in", values, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeNotIn(List<Integer> values) {
            addCriterion("spp_steel_code not in", values, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeBetween(Integer value1, Integer value2) {
            addCriterion("spp_steel_code between", value1, value2, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppSteelCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("spp_steel_code not between", value1, value2, "sppSteelCode");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateIsNull() {
            addCriterion("spp_verify_date is null");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateIsNotNull() {
            addCriterion("spp_verify_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateEqualTo(Date value) {
            addCriterion("spp_verify_date =", value, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateNotEqualTo(Date value) {
            addCriterion("spp_verify_date <>", value, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateGreaterThan(Date value) {
            addCriterion("spp_verify_date >", value, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_verify_date >=", value, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateLessThan(Date value) {
            addCriterion("spp_verify_date <", value, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_verify_date <=", value, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateIn(List<Date> values) {
            addCriterion("spp_verify_date in", values, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateNotIn(List<Date> values) {
            addCriterion("spp_verify_date not in", values, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateBetween(Date value1, Date value2) {
            addCriterion("spp_verify_date between", value1, value2, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppVerifyDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_verify_date not between", value1, value2, "sppVerifyDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateIsNull() {
            addCriterion("spp_predict_date is null");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateIsNotNull() {
            addCriterion("spp_predict_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateEqualTo(Date value) {
            addCriterion("spp_predict_date =", value, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateNotEqualTo(Date value) {
            addCriterion("spp_predict_date <>", value, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateGreaterThan(Date value) {
            addCriterion("spp_predict_date >", value, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_predict_date >=", value, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateLessThan(Date value) {
            addCriterion("spp_predict_date <", value, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_predict_date <=", value, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateIn(List<Date> values) {
            addCriterion("spp_predict_date in", values, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateNotIn(List<Date> values) {
            addCriterion("spp_predict_date not in", values, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateBetween(Date value1, Date value2) {
            addCriterion("spp_predict_date between", value1, value2, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppPredictDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_predict_date not between", value1, value2, "sppPredictDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateIsNull() {
            addCriterion("spp_tender_start_date is null");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateIsNotNull() {
            addCriterion("spp_tender_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateEqualTo(Date value) {
            addCriterion("spp_tender_start_date =", value, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateNotEqualTo(Date value) {
            addCriterion("spp_tender_start_date <>", value, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateGreaterThan(Date value) {
            addCriterion("spp_tender_start_date >", value, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_tender_start_date >=", value, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateLessThan(Date value) {
            addCriterion("spp_tender_start_date <", value, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_tender_start_date <=", value, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateIn(List<Date> values) {
            addCriterion("spp_tender_start_date in", values, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateNotIn(List<Date> values) {
            addCriterion("spp_tender_start_date not in", values, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateBetween(Date value1, Date value2) {
            addCriterion("spp_tender_start_date between", value1, value2, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderStartDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_tender_start_date not between", value1, value2, "sppTenderStartDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateIsNull() {
            addCriterion("spp_tender_end_date is null");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateIsNotNull() {
            addCriterion("spp_tender_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateEqualTo(Date value) {
            addCriterion("spp_tender_end_date =", value, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateNotEqualTo(Date value) {
            addCriterion("spp_tender_end_date <>", value, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateGreaterThan(Date value) {
            addCriterion("spp_tender_end_date >", value, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_tender_end_date >=", value, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateLessThan(Date value) {
            addCriterion("spp_tender_end_date <", value, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_tender_end_date <=", value, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateIn(List<Date> values) {
            addCriterion("spp_tender_end_date in", values, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateNotIn(List<Date> values) {
            addCriterion("spp_tender_end_date not in", values, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateBetween(Date value1, Date value2) {
            addCriterion("spp_tender_end_date between", value1, value2, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppTenderEndDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_tender_end_date not between", value1, value2, "sppTenderEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateIsNull() {
            addCriterion("spp_quote_start_date is null");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateIsNotNull() {
            addCriterion("spp_quote_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateEqualTo(Date value) {
            addCriterion("spp_quote_start_date =", value, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateNotEqualTo(Date value) {
            addCriterion("spp_quote_start_date <>", value, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateGreaterThan(Date value) {
            addCriterion("spp_quote_start_date >", value, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_quote_start_date >=", value, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateLessThan(Date value) {
            addCriterion("spp_quote_start_date <", value, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_quote_start_date <=", value, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateIn(List<Date> values) {
            addCriterion("spp_quote_start_date in", values, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateNotIn(List<Date> values) {
            addCriterion("spp_quote_start_date not in", values, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateBetween(Date value1, Date value2) {
            addCriterion("spp_quote_start_date between", value1, value2, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteStartDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_quote_start_date not between", value1, value2, "sppQuoteStartDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateIsNull() {
            addCriterion("spp_quote_end_date is null");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateIsNotNull() {
            addCriterion("spp_quote_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateEqualTo(Date value) {
            addCriterion("spp_quote_end_date =", value, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateNotEqualTo(Date value) {
            addCriterion("spp_quote_end_date <>", value, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateGreaterThan(Date value) {
            addCriterion("spp_quote_end_date >", value, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_quote_end_date >=", value, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateLessThan(Date value) {
            addCriterion("spp_quote_end_date <", value, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_quote_end_date <=", value, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateIn(List<Date> values) {
            addCriterion("spp_quote_end_date in", values, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateNotIn(List<Date> values) {
            addCriterion("spp_quote_end_date not in", values, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateBetween(Date value1, Date value2) {
            addCriterion("spp_quote_end_date between", value1, value2, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppQuoteEndDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_quote_end_date not between", value1, value2, "sppQuoteEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateIsNull() {
            addCriterion("spp_contract_start_date is null");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateIsNotNull() {
            addCriterion("spp_contract_start_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateEqualTo(Date value) {
            addCriterion("spp_contract_start_date =", value, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateNotEqualTo(Date value) {
            addCriterion("spp_contract_start_date <>", value, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateGreaterThan(Date value) {
            addCriterion("spp_contract_start_date >", value, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_contract_start_date >=", value, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateLessThan(Date value) {
            addCriterion("spp_contract_start_date <", value, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_contract_start_date <=", value, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateIn(List<Date> values) {
            addCriterion("spp_contract_start_date in", values, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateNotIn(List<Date> values) {
            addCriterion("spp_contract_start_date not in", values, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateBetween(Date value1, Date value2) {
            addCriterion("spp_contract_start_date between", value1, value2, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractStartDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_contract_start_date not between", value1, value2, "sppContractStartDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateIsNull() {
            addCriterion("spp_contract_end_date is null");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateIsNotNull() {
            addCriterion("spp_contract_end_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateEqualTo(Date value) {
            addCriterion("spp_contract_end_date =", value, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateNotEqualTo(Date value) {
            addCriterion("spp_contract_end_date <>", value, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateGreaterThan(Date value) {
            addCriterion("spp_contract_end_date >", value, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_contract_end_date >=", value, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateLessThan(Date value) {
            addCriterion("spp_contract_end_date <", value, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_contract_end_date <=", value, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateIn(List<Date> values) {
            addCriterion("spp_contract_end_date in", values, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateNotIn(List<Date> values) {
            addCriterion("spp_contract_end_date not in", values, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateBetween(Date value1, Date value2) {
            addCriterion("spp_contract_end_date between", value1, value2, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppContractEndDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_contract_end_date not between", value1, value2, "sppContractEndDate");
            return (Criteria) this;
        }

        public Criteria andSppRowNoIsNull() {
            addCriterion("spp_row_no is null");
            return (Criteria) this;
        }

        public Criteria andSppRowNoIsNotNull() {
            addCriterion("spp_row_no is not null");
            return (Criteria) this;
        }

        public Criteria andSppRowNoEqualTo(String value) {
            addCriterion("spp_row_no =", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoNotEqualTo(String value) {
            addCriterion("spp_row_no <>", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoGreaterThan(String value) {
            addCriterion("spp_row_no >", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoGreaterThanOrEqualTo(String value) {
            addCriterion("spp_row_no >=", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoLessThan(String value) {
            addCriterion("spp_row_no <", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoLessThanOrEqualTo(String value) {
            addCriterion("spp_row_no <=", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoLike(String value) {
            addCriterion("spp_row_no like", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoNotLike(String value) {
            addCriterion("spp_row_no not like", value, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoIn(List<String> values) {
            addCriterion("spp_row_no in", values, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoNotIn(List<String> values) {
            addCriterion("spp_row_no not in", values, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoBetween(String value1, String value2) {
            addCriterion("spp_row_no between", value1, value2, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppRowNoNotBetween(String value1, String value2) {
            addCriterion("spp_row_no not between", value1, value2, "sppRowNo");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateIsNull() {
            addCriterion("spp_plan_date is null");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateIsNotNull() {
            addCriterion("spp_plan_date is not null");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateEqualTo(Date value) {
            addCriterion("spp_plan_date =", value, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateNotEqualTo(Date value) {
            addCriterion("spp_plan_date <>", value, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateGreaterThan(Date value) {
            addCriterion("spp_plan_date >", value, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateGreaterThanOrEqualTo(Date value) {
            addCriterion("spp_plan_date >=", value, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateLessThan(Date value) {
            addCriterion("spp_plan_date <", value, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateLessThanOrEqualTo(Date value) {
            addCriterion("spp_plan_date <=", value, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateIn(List<Date> values) {
            addCriterion("spp_plan_date in", values, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateNotIn(List<Date> values) {
            addCriterion("spp_plan_date not in", values, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateBetween(Date value1, Date value2) {
            addCriterion("spp_plan_date between", value1, value2, "sppPlanDate");
            return (Criteria) this;
        }

        public Criteria andSppPlanDateNotBetween(Date value1, Date value2) {
            addCriterion("spp_plan_date not between", value1, value2, "sppPlanDate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}